#
| Represents numerical digits or spaces.
When the original number is converted, # characters are ignored unless the number of # characters in the format string extends beyond the number of significant digits in the original value. Then, for every additional # that appears, a space is added to the string.
| If your original value is 125.34:
- the format string "#" produces the string "125" (number of significant digits exceeds the number of # characters)
- the format string "###.##" produces the string "125.34" (number of significant digits equal to number of # characters)
- the format string "####.###" produces the string "125.34" (number of significant digits is less than the number of # characters).
|
0
| Represents numerical digits or zeros (0).
When the original number is converted, 0 characters are ignored unless the number of 0 characters in the format string extends beyond the number of significant digits in the original value. Then, for every additional 0 that appears, a zero is added to the string.
| If your original value is 125.34:
- the format string "0" produces the string "125" (number of significant digits exceeds the number of 0 characters)
- the format string "000.00" produces the string "125.34" (number of significant digits equal to number of 0 characters)
- the format string "0000.000" produces the string "0125.340" (number of significant digits is less than the number of 0 characters).
# and 0 characters can be combined in format strings. If your original value is 125.34:
- the format string "####.0000" produces the string "125.3400".
- A comma (,)
- A decimal point (.) indicates where a decimal separator should appear. The actual character that appears as a decimal separator in the resulting string can be changed.
|